MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

12 rows where Object Name = 5982

View and edit SQL

Suggested facets: Culture, Artist Role, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Nationality, Artist Begin Date, Artist End Date, Object Date, Object Begin Date, Object End Date, Medium, Artist Begin Date (date), Artist End Date (date)

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Repository
67396 1995.442.11a, b 0 0 80059 Costume Institute 8 Trench coat 5982 Trench coat Italian 36         Design House|Designer 198   Giorgio Armani|Giorgio Armani Italian, founded 1974|Italian, born 1934   Armani|Armani Giorgio 5285 Italian|Italian 93 1974 |1934-07-11 9999 |2034 ca. 1987 1982 1992 synthetic 15169   Gift of Clay H. Barr, in memory of Jay D. A. Barr, 1995                           Metropolitan Museum of Art, New York, NY 1
69380 2001.393.25a, b 0 0 82726 Costume Institute 8 Trench coat 5982 Trench coat American 1         Designer 5   Geoffrey Beene American, Haynesville, Louisiana 1927–2004 New York   Beene, Geoffrey 5306 American 1 1927-08-30 2004-09-28 1970s 1970 1979 metallic, metal 15857   Gift of Geoffrey Beene, 2001                           Metropolitan Museum of Art, New York, NY 1
73606 1981.345.5a, b 0 0 92081 Costume Institute 8 Trench coat 5982 Trench coat French 7         Designer 5   Pierre Cardin French, born San Biagio di Callalta, Italy, 1922   Cardin, Pierre 5275 French, born Italy 139 1922-07-02 2022 1969 1969 1969 cotton, synthetic blend 16782   Gift of Francis M. Spencer, 1981                           Metropolitan Museum of Art, New York, NY 1
75528 1977.333.20a, b 0 0 96952 Costume Institute 8 Trench coat 5982 Trench coat American 1         Designer 5   Serendipity 3 American, opened 1954   Serendipity 3 5382 American 1 1954   1976 1976 1976 cotton 3340   Gift of Serendipity 3 Denim Clothing Collection, 1977                           Metropolitan Museum of Art, New York, NY 1
77816 2004.181a–f 0 0 102882 Costume Institute 8 Trench coat 5982 Trench coat British 6         Design House 209   Burberry British, founded 1856   Burberry 5974 British 7 1856 9999 ca. 1968 1963 1973 a,c,d) cotton, plastic; b,e,f) cotton, leather 17514   Anonymous Gift, 2004                           Metropolitan Museum of Art, New York, NY 1
85139 2005.291a–g 0 0 119471 Costume Institute 8 Trench coat 5982 Trench coat American 1         Designer|Manufacturer 3   Bill Blass|PBM American, Fort Wayne, Indiana 1922–2002 New Preston, Connecticut   Blass, Bill|PBM 5699 American 1 1922-08-22 2002-06-12 ca. 1968 1963 1973 a) cotton, plastic; b-d) cotton, metal; e-f) cotton 18331   Gift of Edward De Luca, in memory of Bill Blass and Steven Kaufmann, 2005                           Metropolitan Museum of Art, New York, NY 1
88143 2006.271.26a–f 0 0 129586 Costume Institute 8 Trench coat 5982 Trench coat British 6         Design House 209   Burberry British, founded 1856   Burberry 5974 British 7 1856 9999 1970s 1970 1979 a) cotton, silk, plastic; b) wool, silk; c) cotton, leather; d,e) cotton; f) cotton, silk 18749   Bequest of Yolande Fielding–Scheftel, 2006                           Metropolitan Museum of Art, New York, NY 1
89614 2009.306a–d 0 0 154394 Costume Institute 8 Trench coat 5982 Trench coat French 7         Designer|Secondary Line|Design House 216   Yves Saint Laurent|Yves Saint Laurent Rive Gauche|Yves Saint Laurent, Paris French (born Algeria) Oran 1936–2008 Paris|French, founded 1966|French, founded 1961   Saint Laurent Yves|Saint Laurent Rive Gauche Yves|Saint Laurent Yves, Paris 5445 French|French|French 103 1936 |1966 |1961 2008 |9999 |9999 fall/winter 1980–81 1980 1981 leather, metal 15127   Catharine Breyer Van Bomel Foundation Fund, 2009                           Metropolitan Museum of Art, New York, NY 1
89650 2010.134a–d 0 0 155217 Costume Institute 8 Trench coat 5982 Trench coat French 7         Designer|Design House 202   Martin Margiela|Maison Martin Margiela Belgian, born 1957|founded 1988   Margiela Martin|Margiela Maison Martin 5647 Belgian|French 168 1957 |1988 2057 |2088 fall/winter 2005–6 2005 2006 cotton, synthetic 15314   Purchase, Gould Family Foundation Gift, in memory of Jo Copeland, 2010                           Metropolitan Museum of Art, New York, NY 1
93415 2010.358a–d 0 0 162360 Costume Institute 8 Trench coat 5982 Trench coat Spanish 13         Designer 5   Miguel Adrover Spanish, born 1965   Adrover Miguel 6597   1965 2065 fall/winter 2000–2001 2000 2001 cotton/synthetic, leather, metal 19742   Gift of Miguel Adrover, 2010                           Metropolitan Museum of Art, New York, NY 1
93469 2011.162a, b 0 0 162909 Costume Institute 8 Trench coat 5982 Trench coat Dutch 4         Design House 209   Viktor and Rolf Dutch, founded 1993   Viktor and Rolf 7474 Dutch 11 1993 1993 fall/winter 2006–7 2006 2007 cotton 3340   Purchase, Gould Family Foundation Gift, in memory of Jo Copeland, 2011                           Metropolitan Museum of Art, New York, NY 1
439789 2016.729a–d 0 0 733751 Costume Institute 8 Trench coat 5982 Trench coat Japanese 35         Design House|Design House|Designer 255   Burberry|Comme des Garçons|Rei Kawakubo British, founded 1856|Japanese, founded 1969|Japanese, born 1942   Burberry|Comme des Garçons|Kawakubo Rei 55930   1856 |1969 |1942 9999 |9999 |2042 2016 2016 2016 cotton, polyester, metal 16797   Purchase, Friends of The Costume Institute Gifts, 2016                           Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 140.059ms · Data license: CC0 · Data source: metmuseum/openaccess